<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
</head>
<body style="font-family: Arial; font-size: 10 px">
<font size=2>
<u><b><font color="#000080">SQL Query Tool</font></b></u>
<p>
This is intended to be the main working window when querying or altering the
information stored in the data base.<br>
And it looks more or less as follows:<p>
<img border="0" src="../images/sql_query_tool.gif">
<br>
<br>
<table border="1" width="100%" id="table1" bordercolorlight="#000000" bordercolordark="#000000" cellpadding="3" cellspacing="0">
	<tr>
		<td height="22"><img border="0" src="../images/bullet_1.gif" width="30" height="30"></td>
		<td height="22"><font size=2>
		<b><u>SQL Editor ToolBar</u><br>
		</b>Buttons to perform actions associated with the SQL Command. By placing the mouse over them a brief text describing the 
		action associated with the button will appear.<br>
		<br>
		Besides usual editing actions, it contains:<br>
		a) A combo box with some simple, but useful, templates for most common SQL commands.<br>
		b) A menu containing all functions that the DBMS support (obviously this set can change from one to another DBMS).<br>
		c) A button to execute (play) SQL command, alternatively F5 will perform the same action<br>
		d) A spinner control to set the maximum number of records that will be retrieve by SELECT commands.</font></td>
	</tr>
	<tr>
		<td height="30">

<img border="0" src="../images/bullet_2.gif" width="30" height="30"></td>
		<td height="60">
<font size=2>
<b><u>SQL Editor</u><br>
</b>Where you type the SQL command to be executed.</font></td>
	</tr>
	<tr>
		<td height="30">

<img border="0" src="../images/bullet_3.gif" width="30" height="30"></td>
		<td height="22">
<font size=2>
<b><u>History</u><br>
</b>Storing all SQL commands executes in current session. Selecting one will replace the text in the SQL editor area.</font></td>
	</tr>
	<tr>
		<td height="120">

		<img border="0" src="../images/bullet_4.gif" width="30" height="30"></td>
		<td height="120"><font size=2><u><b>Data (Result Set Table)</b></u><br>
		Where the result of the execution (if the command was a query) is shown.
<br>
		Otherwise the content will not change.
<br>
		<br>
		You can browse the result of your query, and <u>if the JDBC Driver</u> that you are using supports &quot;updatable result 
		sets&quot;, then you will be able also to change the data directly in the table and save it to the data base.
		To do so, you should have the grid in &quot;editing mode&quot;: click the locker icon in bottom tool bar.<br>
		<br>
		It can also happen that the driver that you are using allows you to change certain data and not others, depending on the 
		query that you execute.<br>
		Only as a hint: the more complex is the query the lower probability you will have to be allowed to change the data.<br>
		<br>
		Any case, the application relays totally on the JDBC Driver, so, if you can not change data coming from even the simplest 
		query, blame the driver, not JDBC Manager.</font></td>
	</tr>
	<tr>
		<td height="22">

		<img border="0" src="../images/bullet_5.gif" width="30" height="30"></td>
		<td height="22"><font size=2><b><u>Data Toolbar</u><br>
		</b>With buttons to perform actions associated with data grid (table).</font><p><font size="2">By placing the mouse over 
		them a brief text describing the action associated with the button will appear. All these actions affect to the table 
		(results obtained by the SQL query). </font></td>
	</tr>
</table>
</body>
</html>